﻿	CREATE TABLE public.country
	(
	    /***************************************************************************************************
	    **  Table:	    public.country
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    Represents a country.
	    **
	    **  Fields (6):
	    **
	    **      a2_code         - 
	    **      a3_code         -
	    **      num_code        -
	    **      full_name       -
	    **      short_name      -
	    **      display_name    -
	    **
	    **  Constaints (1):
	    **
	    **      country_pk      - 
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
        id              character (2)           NOT NULL,
        a3              character (3)           NULL,
        num             int                     NULL,
        full_name       character varying(128)  NULL,
        short_name      character varying(128)  NULL,
        display_name    character varying(128)  NULL,
        
	    -- [Constraints]
	    CONSTRAINT country_pk           PRIMARY KEY ("id")
	);
